Round 1: Telephonic Screening

✅ A summary of my professional experience as a Data Engineer.

✅ Highlights of the tools and technologies I have worked with, such as Python, SQL, Azure, Spark, and Snowflake.

✅ My experience with data pipelines, storage solutions, and job scheduling.

✅ Reasons for exploring a new opportunity.

Round 2: Technical

✅ SQL

🔹 Writing complex queries involving joins, window functions, and aggregations.

🔹 Optimizing query performance and understanding indexing.

✅ Spark

🔹 Explaining the architecture of Apache Spark.

🔹 Discussing concepts such as RDDs, DataFrames, and Spark optimization techniques.

🔹 Troubleshooting performance issues in Spark jobs.

✅ Azure

🔹 My experience with Azure services, including Data Factory, Databricks, and Data Lake Storage.

🔹 Setting up pipelines for data movement and transformation.

✅ Scenario-Based Questions

🔹 Designing a scalable data pipeline for incremental data processing.

🔹 Handling large datasets efficiently in a cloud-based architecture.

Additionally, this round included:

✅ Detailed questions on Spark architecture and memory management.

✅ Coding tasks:

🔹 Two Python coding questions focused on string manipulations.

🔹 Three coding questions that required implementations in both PySpark and SQL.

✅ Azure Data Factory (ADF) questions to plan pipelines for different scenarios.

Round 3: Client Technical and Managerial 

The final round was conducted with the client team, consisting of technical and managerial representatives. This interactive session focused on:

✅ Technical Questions:

🔹 Explaining a project I had worked on, highlighting the architecture and technologies used.

🔹 Discussing challenges I faced, such as data quality issues, performance bottlenecks, and scaling pipelines, along with how I resolved them.

✅ Managerial Questions:

🔹 My approach to time management and handling multiple priorities.

🔹 Examples of collaborating with cross-functional teams.

🔹 Situational questions to evaluate my decision-making and leadership abilities.

✅ Final Thoughts:

The interview process at Tech Mahindra was rigorous yet rewarding. It provided a platform to showcase my technical skills and problem-solving abilities while offering insight into the role's expectations and challenges.

✅ Preparation Tips:

🔹 Core technical skills, including SQL, Spark, and cloud platforms like Azure.

🔹 Clear and concise explanations of your project experiences.

🔹 Scenario-based problem-solving questions that demonstrate your expertise.